Excel 2019 - Expert - PivotTables
      This course is part of the MOS exam 77-728 range that will teach you the essential skills to successfully pass the Microsoft Office Specialist (MOS) Expert certification exam.      
      PivotTables      
      Upon successful completion you will be able to:

1. Create PivotTables;
2. Set the Layout for PivotTables;
3. Group PivotTable Data;
4. Arrange PivotTables;
5. Add Calculated Fields;
6. Remove Calculated Fields;
7. Use GETPIVOTDATA.
      
      Working with PivotTables      
      Upon successful completion you will be able to:

1. Use Cube Functions;
2. Update PivotTable Data;
3. Display PivotTable Records;
4. Show Report Filter Pages;
5. Customise Fields;
6. Hide Field Headers;
7. Use PivotTable Report Options;
8. Format PivotTables.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2019 - Expert - PivotTables :
Program Training Courses - Microsoft Excel Expert 2019 :
Office Suite Training Courses - Microsoft Office 2019 / Office 365 :
© 2020 Online Training Masters